home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Developer Source 18
/
Developer Source Volume 18 (I-MODE Publications, Inc.)(2000).iso
/
oracl
/
mar97
/
koopf102.gif
< prev
next >
Graphics Interchange Format
|
1998-02-10
|
15KB
|
630x197
|
4-bit (14 colors)
Labels:
text
|
font
|
number
|
screenshot
|
black and white
|
document
OCR:
FIGURE 2: Loading data in primary key order forces good clustering. Note the difference in percent of clustering for rows. blkixchk.sql Allec. 8 Uniqueness Avg. Leaf Blocks Avg. Data Blocks Distinct Number Pct. Cluster Index Blocks Level Blocks per Key por Key Key of Rows Clustering for Rows Estimate Statistics: JKOOPMI,TES1_PK UNIQUE 775 JKOOPM1.TESTI_PI_AUDT_DT 2 518 1 1 79,794 79,139 1,665 2.10 NONUNIQUE 660 2 646 9 143 68 79,139 52,577 66.90 Compute Statistics: JKOOPMI.TESTI_PK UNIQUE 775 2 512 1 1 79,112 79,112 1,156 JKOOPMI, TESTI_PL_AUDT_DT 1.49 NONUNIQUE 660 2 6.40 9 773 68 79,112 52,630 66.53 blkixsts.sql Usable Usable Deleted Spoce Space in Const Deleted Leaf Most Rows Leof Branch B-Trop in Leof Bronch Gets Used Branch Leaf Rows Repect Nome Space Blocks Block Blocks Block per po Pct. Rows Rows Length Ke Access (K) (K] Used JKOOPM1.TEST1_PI_AUDT_DT 636 3924 635 5 3956 JKOOPM1.TEST1_PK 0 1163 585 2456 512 3924 3 2056 2326 1480 61.00 1 1 4 1974 1957 100.00
(2000).iso/oracl/mar97/koopf102.gif){kind=small}
(2000).iso/oracl/mar97/koopf101.gif){kind=link}
(2000).iso/oracl/mar97/koopf105.gif){kind=link}